Create Sheets
Description
Google Spreadsheets: Create Sheet step, creates a new sheet in a spreadsheet on Google Drive.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Connection: | Refer Prerequisites and References above to get the connection attributes. | |
| 2 | Client ID | Specify Client ID of the Google application. The data type is String. This field is mandatory. |
| Client Secret: | ||
| 3 | Accept Values from fields | Leave checkbox unchecked to accept Client Secret value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 4 | Client Secret | Specify Client Secret of the Google application. If checkbox above is enabled Client Secret field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Client Secret field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory. |
| Refresh Token: | ||
| 5 | Accept Values from fields | Leave checkbox unchecked to accept Secret Key value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 6 | Refresh Token | Specify a Refresh Token to obtain a new Access Token. Note: Refresh Token expires if idle for 6 months. If checkbox above is enabled Refresh Token field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Refresh Token field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory. |
| 7 | Button: Test Connection | Verifies whether the connection is established or not. Note: For the purpose of verification fields coming from previous steps are not allowed since field values can only be accessed when workflow is in running state; only static values and environment variables are allowed. |
| Input Fields: | ||
| 1 | Spreadsheet ID | Specify the unique ID allocated to the spreadsheet. The data type is String. This field is mandatory. Note: To get a spreadsheet ID: In the URL, the spreadsheet ID is the value between "/d/" and "/edit" in the URL of the spreadsheet, as shown in the following image: For example, consider the following URL that refers a Google Sheets spreadsheet: https://docs.google.com/spreadsheets/d/1CJnkal5pj3SLpv-HdmyguX/edit#gid=0 Then the Spreadsheet ID is 1CJnkal5pj3SLpv- HdmyguX. |
| 2 | Sheet Name | Specify a new sheet name to be created. The data type is String. This field is mandatory. |
| 3 | Index | Specify an Index to create a new sheet at a specified position. The data type is Number. Note:If Index is not provided, then the sheet is created at the last position in the spreadsheet. |
| Header Fields: | ||
| 1 | Header(s) | Specify the header name to be created. For multiple headers provide semi-colon (;) separated values to be written in a new sheet. The data type is String. Note: - If a Header is not provided or Invalid Header is provided, then the sheet is created without headers. - A blank header name is set, if two consecutive semi-colons (;;) are provided. |
| 2 | Row Index | Specify Row Index to write a header to specified row number. For example, if the header is to be written at row 1 of the newly created sheet then Row Index=0. The data type is Number. Note: The maximum value for the Row index should be 999 and the column index should be 25. The sheet will be created in Google if the values exceed, but the plugin will be aborted with an error. |
| 3 | Column Index | Provide Column Index to start writing header from the specified column. For example, if the header is to be written from Column A of the newly created sheet then Column Index=0. The data type is Number. Note:The maximum value for the Row index should be 999 and the column index should be 25. The sheet will be created in Google if the values exceed, but the plugin will be aborted with an error. |
| Output Field | ||
| 1 | Sheet ID | Specify an output field to hold the Sheet ID of the created sheet. The date type is string. This field is mandatory. |